#!/usr/bin/env python
# $Id: netdot2ip.py df54dec975f4 2012/09/09 20:22:40 pgurumur $
# Copyright (c) 2012 Prabhu Gurumurthy <pgurumur@gmail.com>
#
# Permission to use, copy, modify, and distribute this software for any
# purpose with or without fee is hereby granted, provided that the above
# copyright notice and this permission notice appear in all copies.
#
# THE SOFTWARE IS PROVIDED "AS IS" AND THE AUTHOR DISCLAIMS ALL WARRANTIES
# WITH REGARD TO THIS SOFTWARE INCLUDING ALL IMPLIED WARRANTIES OF
# MERCHANTABILITY AND FITNESS. IN NO EVENT SHALL THE AUTHOR BE LIABLE FOR
# ANY SPECIAL, DIRECT, INDIRECT, OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
# WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN
# ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS ACTION, ARISING OUT OF
# OR IN CONNECTION WITH THE USE OR PERFORMANCE OF THIS SOFTWARE.
#

__version__  = "$Revision: df54dec975f4 $"
__author__   = "$Author: pgurumur $"
__modified__ = "$Date: 2012-09-09 20:22:40Z $"

from venya.lib import ip
from venya.lib import sql
from venya.lib import stdlib

if __name__ == "__main__":
   database = "netdot"
   username = "ops"
   hostname = "10.55.84.216"
   password = "rk807uuN"

   handle = sql.mysql(database, hostname, username, password)
   ipblock = handle.ipblock

   count = 0
   ipaddr = {}
   for ix in ipblock.q.filter(ipblock.version == 4).filter(
         ipblock.parent == 0).order_by(ipblock.address).values(
               ipblock.address, ipblock.prefix):

      ipaddr[int(ix[0])] = int(ix[1])

   for ix in sorted(ipaddr.keys()):
      address = ip.ip(ix, prefix = ipaddr[ix], version = 4)
      if not address.private:
         print(address)
   

